<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en"><title id="gr143896">pg_inherits</title><body><p>The <codeph>pg_inherits</codeph> system catalog table records information about table inheritance
      hierarchies. There is one entry for each direct child table in the database. (Indirect
      inheritance can be determined by following chains of entries.) In Greenplum Database, inheritance relationships are created by both the
        <codeph>INHERITS</codeph> clause (standalone inheritance) and the <codeph>PARTITION
        BY</codeph> clause (partitioned child table inheritance) of <codeph>CREATE
      TABLE</codeph>.</p><table id="gr143898"><title>pg_catalog.pg_inherits</title><tgroup cols="4"><colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="86pt"/><colspec colnum="3" colname="col3" colwidth="85pt"/><colspec colnum="4" colname="col4" colwidth="147pt"/><thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row></thead><tbody><row><entry colname="col1"><codeph>inhrelid</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">pg_class.oid</entry><entry colname="col4">The OID of the child table.</entry></row><row><entry colname="col1"><codeph>inhparent</codeph></entry><entry colname="col2">oid</entry><entry colname="col3">pg_class.oid</entry><entry colname="col4"> The OID of the parent table.</entry></row><row><entry colname="col1"><codeph>inhseqno</codeph></entry><entry colname="col2">int4</entry><entry colname="col3"/><entry colname="col4">If there is more than one direct parent for
a child table (multiple inheritance), this number tells the order in
which the inherited columns are to be arranged. The count starts at 1.</entry></row></tbody></tgroup></table></body></topic>